<?php
set_time_limit(0);
require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;



$inputFileName = 's.xls';
 

/** Load $inputFileName to a Spreadsheet Object  **/
$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($inputFileName);
$sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);

 

$i=1;
foreach($sheetData as $v){
    if($i > 0){
        $name=trim($v['A']);
        echo '<option value="'.$name.'">'.$name.'</option>';
         
    }
    $i++;
} 
 
 


